Overview

In the SAS Deployment Manager, if you use the Update Passwords tool to change a password, and you later use the Update Host Name References tool to update a host name, the omr_host property of the sas_application_property table in the SAS Shared Services database might not be properly updated.

When the database is not properly updated, you cannot invoke any of the SAS web applications. In addition, the SAS^® Web Application Server log contains references to the old host name.

To correct the problem, you must manually update the omr_host property of the sas_application_property table in the SAS Shared Services database.

Update using the pgAdmin III tool

1. Access the pgAdmin III tool as described in the topic "SAS Web Infrastructure Platform Data Server" in the SAS^® 9.4 Intelligence Platform: Middle-Tier Administration Guide.
2. Connect to the Shared Services database.
3. Under Databases ► SharedServices ► Schemas ► public ► Tables, select the sas_application_property table.
4. Right-click the sas_application_property table and select View Data ► View All Rows.
5. In the property_nm variable, select the row that contains omr_host. Check the value for property_value_txt. If the value is not correct, double click property_value_txt and change the host name to the correct value.
6. Click Save the changed row.
7. Restart the middle-tier servers.

Update using the command line

1. Start a terminal session.

2. Export the following, replacing SASHOME with the actual path:

   POSTGRES_HOME=SAS_HOME/SASWebInfrastructurePlatformDataServer/9.4
   export PATH=${POSTGRES_HOME}/bin:$PATH
   export LD_LIBRARY_PATH=${POSTGRES_HOME}/lib:$LD_LIBRARY_PATH

3. Run the following psql, supplying the user ID (typically, dbmsowner), and entering the SharedServices password when prompted.

psql -h localhost -p 9432 -u userID -d SharedServices -c "select * from sas_application_property;"

4. Check the result to verify if an update is needed. If an update is needed, execute the following line:

psql -h localhost -p 9432 -u userID -d SharedServices -c "UPDATE public.sas_application_property SET property_value_txt='newhostname' WHERE property_nm='omr_host';" 

5. Restart the middle-tier servers.

Operating System and Release Information